SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509102 LIMIT 1 [ RunTime:0.001954s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509102 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941973,228220,299799,302285,477547,449639,501638,454594,746332,705575,820085,262850,972396,257536,54789,392489,577437,1023389,231478,419145,931147,151552,872673,639813,919726,461371,23241,555036,581171,588376,743977,972037,894141,257605,397556,34663,328021,43765,713663,445112,914660,825860,305458,83999,76560,399917,324326,992251,416692,845634,930936,477905,534752,948205,216966,848725,899247,210170,600660,107787) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]