SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419706 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419706 [ RunTime:0.001722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574051,1016055,597854,137394,506895,648043,912011,533217,838166,756804,1011691,506684,958405,192242,98301,992505,256819,141122,478500,142788,724922,917642,348143,707123,246299,751635,662064,230965,747103,106544,493483,398506,1017392,645425,715163,970653,440742,828587,336670,80950,213571,194714,788931,604198,959113,569500,70164,506448,878281,544230,973952,956626,408943,725654,556942,452817,50499,140300,121161,1013663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]