SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 97310 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 97310 [ RunTime:0.002255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93985,938440,1040121,682825,378081,1041807,503625,215116,55025,402118,37849,949229,992825,225242,674696,285415,749918,822833,404933,1008199,947102,717638,662028,644436,644452,466541,908227,543184,439367,622178,51697,122056,421966,13777,848276,93850,418648,672506,975347,401780,769590,496589,178236,976238,758283,737961,546800,730824,369498,955893,570430,33667,855096,677958,561133,490245,660501,754568,669418,384062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 97310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 97310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]