SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807628 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807628 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (903543,22688,361487,732412,375253,448028,140288,695123,749557,407098,1018422,778036,515607,15875,345893,669720,871392,200099,545834,536216,90791,228906,828416,908077,171577,395682,654651,417757,53965,653332,26783,623392,5063,381604,66934,934580,542365,283283,708866,25121,940999,384596,696079,215617,513745,915668,797200,402406,270885,831891,1046847,433016,61957,844171,688885,414503,937562,321737,31182,891741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]