SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 302843 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 302843 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252701,71629,180851,419649,108310,314227,967166,420906,1035271,168415,910582,122247,120614,236838,669307,442657,754324,468883,70588,263380,286222,97418,157165,827279,309843,550025,1036803,397216,428360,822408,732280,881790,695821,875136,38130,629284,847588,154394,511621,439546,705373,831602,465702,630985,115415,909992,232994,726478,55047,162788,330329,429184,223617,848370,241568,1026436,705588,296540,663989,619456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 302843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 302843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]