SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466832 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466832 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (550073,353908,62813,805015,108666,338178,191319,1024843,693146,495228,80945,911207,671338,938703,620326,775567,473578,879341,450104,245339,707685,765992,399342,482719,949452,492527,1027856,650970,561988,7356,455660,1027777,52823,1036144,942623,205428,261650,416767,988337,58684,405159,464504,967893,795450,608396,170193,735149,548462,943834,491662,751917,445251,378509,123281,619349,37649,40529,320785,640744,493733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]