SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012271 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012271 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (195485,308343,645797,439605,375303,949950,761400,472449,460592,149637,547326,762068,822298,21601,589697,252,951003,569775,112871,611284,412094,690295,147743,641520,125843,302986,434570,241651,13858,362830,569026,494510,631014,980401,516375,904069,381147,903714,517747,794536,1010732,758929,814699,392278,14520,800147,725042,788485,778353,652,405487,17923,725552,316812,862071,839398,55877,16202,224338,722062) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]