SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457251 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457251 [ RunTime:0.001594s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603092,574150,898525,375532,411546,556150,871907,765044,540594,796871,18348,291380,610544,746923,869668,53383,50991,492927,884735,589158,783832,545684,362581,755993,738909,785026,642680,703817,326587,242235,14483,813703,255644,397715,980140,357723,140218,7723,1020905,398298,423210,344762,1033641,3139,622669,310876,677337,866193,576033,870963,325222,184348,65223,424084,578577,549482,42735,445536,425053,524363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]