SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 831010 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 831010 [ RunTime:0.003312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325451,343855,41717,442860,1026799,703064,1043920,756643,621868,810100,268385,700280,429983,243881,263522,611093,518782,599803,721422,716168,939763,529305,429619,91212,98668,727996,717111,819760,36878,534069,860061,313284,62477,246556,878819,754295,708848,965803,723896,796104,143668,472273,706353,838678,964687,812347,469254,122451,296813,844447,867554,59075,808870,110249,123208,976346,799852,645173,956705,590588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 831010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 831010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]