SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477196 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477196 [ RunTime:0.002449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320063,31166,336917,496205,27665,215073,478284,714547,13570,157061,885390,106164,684917,29254,860940,662759,656017,135175,511431,747406,904405,1007808,637273,611851,121441,744832,583218,345279,991541,286356,339615,288140,1001553,677308,696406,856215,726972,201083,728316,192349,105609,1020671,89542,1002620,804041,858075,571220,355229,996145,431618,928363,985823,750413,698970,29493,11417,214373,293131,287459,131051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]