SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001797s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318071 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318071 [ RunTime:0.004172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262225,255945,275035,386340,893779,864537,657183,509685,538371,795351,878033,272655,800887,510111,546427,582391,147358,479912,279937,881069,894929,807902,664409,97019,500227,983668,1039392,340639,415832,212749,213946,1047607,783993,226211,1032222,475502,851093,922543,400873,556566,719650,639273,888265,410472,891111,461104,78273,683770,194577,871672,487123,723510,286012,110049,918325,662885,635819,919646,621299,1023245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]