SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450517 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450517 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986973,4527,100823,767900,15372,185569,915871,1002157,417837,320744,31551,978614,204749,197067,1002492,51766,46745,531410,589935,661371,481541,77062,561660,359831,458524,956477,963513,436717,804060,85762,293145,426221,983467,747681,70560,521672,1012813,983353,556241,635385,273281,748860,580808,947570,265459,726247,375406,524484,465005,235692,543042,769161,319577,1023098,888905,578388,549880,675114,408159,983393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]