SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565802 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565802 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674983,700082,373460,134702,327083,464472,627392,717001,202078,32015,542865,971717,259843,379069,575137,14473,907993,597108,609310,925369,965544,412059,824265,582740,725350,604183,523532,85841,907465,154822,879404,680161,528987,788584,883978,402804,651190,187804,828726,859270,737540,950890,338461,279895,396880,797550,704529,445418,851165,485478,45198,694324,309738,853077,282129,37036,772648,325782,486296,591056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]