SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420525 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420525 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841046,666085,921053,179599,865501,916891,844326,394316,149189,513013,633550,782280,468645,217233,473500,250753,628456,990733,271092,6981,462727,338821,697419,579549,1048544,774849,966871,716055,412299,362666,960365,545343,1023201,114191,595276,975349,661636,795731,383429,952348,174546,376849,984943,841581,172277,277776,946273,361322,576231,826994,164550,469978,527879,522489,350965,1023231,978594,203508,595602,571414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]