SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50323 LIMIT 1 [ RunTime:0.000591s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50323 [ RunTime:0.001960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190972,973059,36121,867018,647046,564764,634311,1012778,526116,98334,1038946,215891,956863,882593,1021277,760025,147607,526976,156018,713523,679401,571175,444675,211522,896864,483852,760233,162755,80031,651706,10193,532767,861118,612196,515134,987230,761187,870986,219852,559416,597590,612161,845530,999278,974398,551726,961054,490504,753435,2965,404109,945607,699477,654350,762819,96586,542707,261764,484557,742700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]