SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018072 LIMIT 1 [ RunTime:0.001259s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018072 [ RunTime:0.003742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156911,664493,72886,155106,126432,605793,729479,222405,508258,791155,1032888,216464,22014,473423,343430,445993,507367,739489,364509,139811,236192,745446,124655,723320,494275,284348,966461,1010045,542239,345856,703325,265011,88267,546857,788383,131102,882698,252216,555105,451227,510028,416917,848927,778236,649676,517945,103173,882303,87251,343393,1091,510548,915185,689370,553604,748734,1011650,521591,196093,319824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]