SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415944 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415944 [ RunTime:0.002642s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838663,310428,70486,465580,666913,809563,676952,324861,145384,972006,159659,901593,392958,947909,92449,921083,7110,690063,430996,851455,282150,487588,62727,557360,144922,263707,205704,545296,642828,790542,529843,843466,873614,9747,932113,678310,333414,955279,944312,138956,937400,317137,391097,9875,485297,811691,573145,281935,304758,156129,449982,47372,169805,156013,708943,248532,601144,567513,748149,546477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]