SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484930 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484930 [ RunTime:0.003254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (90555,479194,917274,17177,633837,128996,391731,562805,133703,1024097,775601,376194,456131,664399,664200,39680,826393,598374,89324,536865,550195,873597,282012,679184,895092,1007404,115675,154010,360284,255272,898364,432352,692313,491987,579739,199036,652070,1044174,491008,72356,731947,500549,367695,147984,532664,811698,926294,300007,658293,997698,745179,594612,533712,466221,773775,233235,844689,271893,451953,866202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484930 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484930 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001884s ]