SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 62103 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 62103 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017972,150849,431846,732469,309660,573678,231640,757311,373775,763683,283047,279683,156225,680034,491929,117151,683525,652459,284717,854539,424126,116441,579326,347206,630382,550964,849817,610247,927275,101486,586677,706922,227469,851386,400848,341157,132744,163000,643987,454639,347658,145700,81682,688382,775024,700381,192220,587436,897845,590470,761778,607569,195924,430392,82292,688399,501259,241435,995035,374709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 62103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 62103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001041s ]