SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019333 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019333 [ RunTime:0.002536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108490,426262,104311,568676,459982,437961,388615,485248,874493,598433,857529,680199,47309,721361,465155,572104,583821,180979,826794,1023104,498148,358920,1030192,443391,744731,165052,779868,830806,534551,391004,238059,632348,853575,581770,729844,740355,289588,439145,82800,343891,96430,383559,759381,539223,978581,957127,407911,671075,396171,101780,341704,708304,738688,62567,256396,552602,636483,5476,740956,762998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019333 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019333 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]