SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 257520 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 257520 [ RunTime:0.005229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601876,972133,259222,611257,701912,98283,112160,555599,542371,844158,491123,429477,710546,561822,831127,927931,730575,222475,302154,719389,894749,52109,466824,591398,495179,319784,7110,803306,311072,280565,384097,605750,96771,210754,744043,805867,116997,761908,280936,881793,907632,517373,161962,202070,436597,825350,983027,56372,925689,279824,473250,396687,412005,19445,828634,42299,393559,199912,42567,527216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 257520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 257520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]