SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144023 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144023 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78931,492809,387153,708491,2085,571139,792386,7924,166130,921014,140982,500706,94141,177647,645237,205647,906380,167466,1016262,735328,869883,47144,456956,638060,387420,89893,121997,469582,817354,591230,246635,6785,701409,198120,11834,698705,890187,1000152,371292,1013410,383115,186210,684011,574000,717948,256372,305108,804963,419153,361534,1040882,683803,548540,138672,231819,149922,234362,632599,769582,176473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001430s ]