SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 241715 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 241715 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (146312,291375,349295,425685,484391,870710,137873,565568,10591,522969,777672,55380,870947,368960,133628,222034,811398,65441,253899,978117,905647,212048,276690,792673,475999,561461,894826,834948,864228,349269,454569,699606,1011352,496790,868665,615681,689317,408342,147285,569913,228741,636745,664393,1046880,671543,614918,863530,547210,291830,340330,467217,413264,641277,557619,907384,607939,263534,952576,73768,57449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 241715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 241715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001855s ]