SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010087 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010087 [ RunTime:0.001836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (684026,1046151,985652,949549,646404,534162,736004,1026764,821719,730015,249941,717514,758420,186677,219585,365253,889516,28902,426226,547348,742397,395739,271767,414343,51822,181367,726873,629810,724023,75783,418291,847630,278291,98381,885586,401776,279355,889204,311599,117848,217993,395991,821914,514436,625995,685382,439947,540782,296507,210434,1040956,999929,671552,591693,485958,745111,807846,500556,119372,275686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]