SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196453 LIMIT 1 [ RunTime:0.001348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196453 [ RunTime:0.002115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287444,683888,72195,527478,575403,751342,302450,826197,616681,177127,926589,140839,11521,1003077,205199,258540,977828,641918,685409,807887,393189,377912,140297,422695,97249,491842,728414,586825,676403,512579,107148,621161,109028,978197,17633,510287,147940,809924,662093,318668,737987,203357,396793,869590,623691,511264,279914,839187,965648,160304,902374,445247,161065,748017,241642,164547,949967,104320,817029,241936) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]