SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801699 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801699 [ RunTime:0.002242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190043,893590,186547,566892,191570,558392,1031680,361909,98332,463924,718254,146824,124428,345378,738067,1015957,273471,964870,1039564,193793,169858,979261,246992,130514,917550,45293,703635,880458,285460,281714,579265,782010,667484,514417,980545,591796,858711,551044,452707,406914,853084,240012,798284,627493,892778,314492,125483,762565,739274,998274,312022,682268,509700,266311,870836,274297,984184,319614,401992,408002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]