SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 333258 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 333258 [ RunTime:0.001538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734981,901296,64014,895784,422561,10698,118306,31968,499202,579297,522038,863520,455491,284859,946414,638089,922326,719541,665514,100350,812856,207512,616835,530010,705228,506562,880845,252475,725179,859451,491844,1005845,695190,223616,984771,835355,252970,838409,37968,722707,227864,126570,289475,388748,857819,151105,833259,859794,223517,826200,124934,26757,188087,828538,334635,608120,820168,699567,133020,13826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 333258 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 333258 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004216s ]