SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4949 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4949 [ RunTime:0.003650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525332,135629,371302,432535,398395,669212,282398,244970,181896,251463,542078,132810,38752,915223,568955,8778,891132,274369,341708,1001186,799381,177884,700965,987075,348344,62257,813182,593780,793207,243147,114326,772421,315385,563093,522591,818601,122188,26806,471174,926280,497269,817468,798437,406021,459747,989051,469092,596350,747153,802120,1013027,1039143,91404,518517,727168,422768,277890,494894,603679,888031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4949 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4949 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]