SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3190 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3190 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797087,232483,487784,909176,546317,531811,757483,243413,558047,685953,322878,558879,1038210,479680,686356,738119,211615,506626,352405,39215,793395,903111,221813,349650,616990,244847,102998,21895,339996,234449,1036696,430047,956654,300654,515998,420315,990306,389560,672813,735133,362697,285177,843615,408567,1813,161621,628519,610180,64239,1023015,329112,922753,571191,146056,256065,856954,27829,983625,705000,455307) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]