SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44633 LIMIT 1 [ RunTime:0.002305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44633 [ RunTime:0.005541s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869206,534282,876463,661978,616221,13600,230543,172891,294659,892069,544515,915536,204737,589345,587353,685187,399660,372571,367181,1048402,160503,716017,26567,725578,336447,459923,997187,139710,492636,868717,189895,596804,631797,788709,927345,534313,735248,502129,859679,215074,448900,946937,471066,241335,101593,340591,223956,195199,295017,741411,990066,839193,731747,162966,590969,438298,74478,505858,602207,372458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44633 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44633 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005180s ]