SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405806 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405806 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586710,815280,308897,848211,564909,709815,106901,864197,70003,344640,41690,774973,999189,789639,572499,526307,981006,190981,566955,89119,613193,724428,816999,127590,660172,194526,670490,668735,128011,557752,455845,115960,434367,273877,534870,404679,66759,1043995,453800,814206,184139,453572,32800,290402,543567,273604,959696,642905,355372,56547,838578,291009,267158,335079,546833,983427,996715,9113,103734,451446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001302s ]