SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447301 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447301 [ RunTime:0.001434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114894,644670,402675,833331,560873,856122,204220,63091,354201,1044956,228052,204436,786780,833786,562251,301594,883337,1035849,584778,213731,456424,342103,357011,310425,630401,555156,354440,1009860,268407,67382,587125,348119,160362,667049,995693,857072,676917,576428,301015,730444,742058,746281,1001473,493423,322665,230066,886566,670384,827720,448671,178625,955839,466765,246077,270675,1001789,983308,605965,626331,891987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447301 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447301 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]