SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 970504 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 970504 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44624,750285,525965,544503,1026056,629344,774719,188453,611900,341839,790501,802508,778392,590065,773340,950334,190934,821011,698796,9572,940752,839545,281800,241001,784006,385173,697279,981646,27662,923664,528757,61155,548330,70611,443280,7177,820764,509565,951012,262594,749939,1045785,884735,854091,880552,876454,584096,485306,420740,479358,820328,1004242,1026907,912157,559379,663300,94690,1024355,43292,72070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 970504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 970504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]