SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003981 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003981 [ RunTime:0.002478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815597,106950,514539,505810,143567,85612,828960,488362,796274,864963,593906,960145,711932,904935,680554,397795,812152,550532,421720,707571,474385,843451,275690,82786,324731,328932,582835,559455,366134,526781,689704,949064,166998,941479,874071,426560,83397,697158,306483,782639,946874,451429,178700,741417,724492,981215,351146,770283,177393,716641,174338,335005,937142,669763,68138,565508,148961,96295,682309,717333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000740s ]