SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036636 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036636 [ RunTime:0.001541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (289634,249416,320709,499557,473943,145598,840368,78006,336153,530260,390239,774617,582399,574170,24136,155255,1009978,434105,542246,2861,150756,654361,238572,816328,840537,254048,27823,983481,483972,147674,451844,737175,414550,990672,87089,473071,916043,426591,399375,822574,146494,57394,159994,924563,202453,241108,672131,252025,306798,443922,930527,445414,555095,171413,744838,539746,22499,377634,555672,23469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036636 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036636 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001386s ]