SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 142921 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 142921 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114502,967984,739731,555127,542923,100801,492501,695596,37681,673931,50826,886911,827991,861535,351310,943982,609110,400810,649091,208089,586394,469883,270931,969168,802026,68657,976718,279710,544031,153849,337713,687320,1042880,1009099,121357,64873,488533,930638,535853,339667,603208,799521,108891,877357,623557,476716,800985,78481,208586,361192,432426,988820,419331,832346,483036,486336,36988,951209,690917,131766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 142921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 142921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]