SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503750 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503750 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266173,753698,998038,745003,390620,592779,949642,349802,332056,615864,628380,354621,287536,693894,951631,66140,969481,3540,253554,864103,613314,48046,204191,320396,183401,960253,400149,247348,139508,797153,750987,104839,264334,565834,1044319,491025,889646,189577,390595,566020,227674,100965,92495,602777,497543,843761,259364,600835,458225,232026,878509,930503,518726,337809,341421,683277,605770,423220,483246,745577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001125s ]