SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305451 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305451 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587915,801147,502421,753610,614125,303070,803897,567523,88323,929816,623320,201965,738719,344733,705514,817780,960919,854431,63723,363303,252316,788958,922436,681452,799199,3524,765609,1018972,571151,241446,506839,9911,638316,338480,1003363,380597,148573,792109,210973,987222,335171,158262,48371,835604,660467,301832,610102,446976,571339,634537,49696,384622,129113,525662,468263,696305,235373,559193,702150,1022379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]