SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428953 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428953 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618716,523949,660765,794802,882758,924081,717339,397330,557376,939479,468390,618876,378580,919848,59042,1016064,124506,583123,562572,224994,967397,267936,990623,991626,391719,605715,1030132,772847,678159,904789,535190,511347,867572,754467,585288,314648,687323,75850,779841,1040042,942991,763245,434630,1018731,342530,767031,481945,210571,871718,183135,505378,987264,380371,98629,23932,813699,309641,1000226,37064,1006599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428953 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428953 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]