SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416534 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416534 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130894,178800,487542,898595,71136,174694,965190,470342,894275,242638,872372,171362,520837,224592,134525,652383,817283,52835,754995,514655,190584,771477,308911,678742,784332,264153,453156,73912,1045019,318762,123610,546399,1004369,379716,301393,446136,23559,792120,148500,1034162,570813,338185,1024367,884607,193249,846827,908111,84297,30364,1042952,4332,373336,230612,640746,996969,371220,839185,890264,456048,768466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002503s ]