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` = 111903 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111903 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768183,55800,841267,823609,540078,1011840,766614,789832,17655,78739,359075,632709,742580,918303,580641,670559,424357,660715,37478,730813,140532,554068,173125,527611,542302,274716,443880,710085,986774,560585,575442,637226,1018677,15544,641354,366908,444121,375321,374936,249221,311341,677917,1048630,303962,44746,702161,687234,488429,466797,41112,249925,631441,454775,76531,340469,902675,893746,226024,892175,423933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]