SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6857 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6857 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989983,804884,265221,506213,372592,1047892,273898,656249,841559,858429,5210,65190,177773,488271,828589,794505,935889,167657,7346,527176,661896,830566,212291,213089,282461,555625,626264,303546,512678,705228,1015910,1014067,994546,895296,104004,496207,567589,632138,591667,934400,1014734,684148,96707,648451,362458,916135,665990,148474,439279,852133,429417,161852,376834,8131,1031110,581478,182591,484391,640279,544284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6857 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6857 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002212s ]