SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578354 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578354 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004136,385780,153833,1019190,331728,69102,364968,59318,561405,648910,649919,224921,886116,733627,632587,420055,189791,529874,667581,330762,1001969,643182,136763,863256,570858,41763,795644,815797,170981,80346,572981,400844,293773,467982,635132,868417,816778,442653,136084,829492,324963,623451,607263,310802,279153,77891,58653,703139,304337,13524,299808,815803,739985,190865,714750,195829,906560,886182,265712,434622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]