SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 594811 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 594811 [ RunTime:0.002632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (305140,273255,916888,288188,496214,206904,762517,22462,434216,713647,588419,874831,12146,799991,180191,383661,482820,448232,225229,742810,286552,997030,527839,586605,164188,185933,353416,349574,837133,166413,130235,757556,494246,720585,374748,246421,951109,540447,646895,990523,318150,876599,987003,672542,1002526,608662,104145,408371,40561,672555,108132,803346,354423,544545,201983,298527,76090,803486,158144,457262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 594811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000684s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 594811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]