SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048000 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048000 [ RunTime:0.001878s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (82752,779711,495254,110073,1014278,625259,5470,973106,597826,422118,881658,784,1017964,381412,675941,301658,169553,324470,587949,485871,918969,543415,747535,1017577,310436,18702,291466,520676,345880,994784,721293,461805,861303,302396,796949,577352,22788,633230,739929,324012,49837,539418,177843,335766,983782,191532,20448,418486,630663,232885,326650,1047651,846951,166712,652569,475773,977155,944598,86605,935139) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048000 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048000 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]