SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406541 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406541 [ RunTime:0.003665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251935,930031,758765,881787,562575,530596,675696,788867,635704,308353,839583,1024258,203183,879081,498488,201805,372859,859516,824530,929950,294,80582,197934,691516,384347,180674,796276,246629,389547,2559,989957,198625,348189,490752,1035927,965314,464635,97048,66729,740450,907713,393180,682571,352856,835426,187589,649631,343725,826248,397532,997334,479551,453333,67923,942529,1021869,676385,672016,48381,269837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]