SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544251 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544251 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (931587,601913,789176,1016193,551507,570178,722816,928078,100524,85896,883993,996309,897339,598354,625925,560689,52724,879306,269114,918614,466135,862665,1001107,1022886,993807,257761,819284,814908,268390,514964,916767,945668,330306,247617,345805,604103,257227,219254,307096,888899,1038939,948585,634730,13403,422755,10594,795374,383225,937928,662438,685439,608326,271057,57872,553095,665863,525063,209583,167776,771368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]