SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671957 LIMIT 1 [ RunTime:0.002475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671957 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824071,782368,695898,635678,81210,671994,785038,230724,826953,58714,416662,348773,443419,398440,321817,347752,150111,953644,564348,474308,220127,119380,275554,720669,907743,929477,513403,102560,17176,268957,538280,184084,558191,680171,597543,894566,761490,579282,607154,232501,1046466,119268,694662,50419,974142,1044377,864695,147893,84351,702884,255068,740319,366339,705874,142540,198226,1021101,287719,622618,1011857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002461s ]