SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001577s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 519511 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 519511 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519998,63744,549294,302276,450404,818666,874515,319368,131129,588256,611808,1032647,704996,146167,152986,836301,131271,399340,864996,466402,709479,450063,378662,941615,769469,188273,590556,85004,328469,57896,86636,396999,955142,1047629,771250,473268,860380,740475,388924,996483,407102,922166,79145,445456,283352,1017773,60249,325930,364269,612503,109386,455506,751714,932769,27515,396514,696127,282531,634746,233603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 519511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 519511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004197s ]