SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515201 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515201 [ RunTime:0.002698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184558,794884,602365,376468,46933,632103,621576,39917,12195,934270,599173,763199,995510,101461,1043640,581753,918134,170036,834809,742117,69696,777625,343822,379009,868790,586384,1000613,501124,1041526,132710,137021,647878,406151,622461,402261,35710,985600,955086,483762,815050,752530,689602,852063,223756,497969,652425,587379,939084,909294,456937,304816,665374,137704,461568,415431,694497,57442,3130,133772,216069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002877s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]