SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34151 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34151 [ RunTime:0.002889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (790361,848501,366770,673345,603456,623656,473336,163979,572006,761493,612410,227038,106772,638240,1002552,856674,401007,161171,224361,20864,5672,331236,436049,878244,954955,945314,299904,907214,267108,844845,498122,482209,164501,890154,416340,222939,313847,326178,226457,603006,719651,626779,942860,414718,817391,132304,376000,557692,498859,688090,830578,1027851,125283,209256,922448,201323,740217,939306,921202,826509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]