SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007497s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171211 LIMIT 1 [ RunTime:0.001209s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171211 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28611,382275,925529,769166,973593,739494,742372,652399,723543,960440,879206,58378,367438,668796,322434,545490,953992,539604,1015595,689912,450598,279534,197051,386701,738983,433871,759718,805514,102622,385915,607250,476218,511032,77493,1020590,803549,452356,447151,192166,93659,184600,540844,305967,734716,588571,951571,31258,628352,901543,279991,582430,1032770,221437,442377,885231,62463,487532,558769,190996,353160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003935s ]