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` = 150140 LIMIT 1 [ RunTime:0.001612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150140 [ RunTime:0.002027s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444311,963096,182289,890802,946773,755100,565031,76431,487401,319198,864997,560297,1018010,258262,269240,418437,52313,159175,515973,271488,94569,400540,1020646,170761,471060,471664,672717,263828,692069,104673,969228,865181,76254,422821,408084,579223,438916,520339,939816,693714,367989,49568,289665,517750,500366,686533,661244,729749,769419,312958,465750,39978,73146,361135,642651,1007992,792048,306717,860259,909567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003193s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001771s ]