SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318221 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318221 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427209,392295,618041,486366,136577,142963,800096,659758,512984,265644,542382,1024914,516691,520923,901291,921680,795454,5665,603192,355407,746902,1003318,303350,594255,107118,53447,704317,137588,478097,124557,909402,92194,35937,329553,408735,251536,504644,795627,1006628,144224,666809,267561,729931,464714,477400,651376,188439,248167,662425,398953,288584,199245,48438,916344,387832,190458,291106,41485,1045691,375089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]