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` = 415194 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415194 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231570,61157,340253,240067,903133,1044480,693213,54688,452556,81490,152773,81098,970391,321576,197813,533883,794982,386429,934885,1044920,736435,794426,229321,567823,937793,487052,286907,963455,207247,381210,86541,328425,847933,957793,622559,397637,772945,431446,160296,484597,554098,114458,552216,643607,582961,283680,976125,990924,520073,793002,810870,53768,465089,615270,394697,234850,359683,1001647,220103,607976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]