SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460313 LIMIT 1 [ RunTime:0.001293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460313 [ RunTime:0.004406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257782,701030,930820,837956,1001371,458212,681533,221682,143648,226331,421047,881850,89293,16992,539538,118151,690371,22520,901132,6364,830673,1014760,154606,454001,509830,695270,870624,542233,588902,419377,76825,789496,284913,522103,131670,51529,372764,621118,217303,264915,81603,831598,254230,573238,1013426,823545,369440,946368,782646,800294,144449,372280,837082,209650,236106,909233,7381,1043308,708370,1030512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000727s ]