SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409060 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409060 [ RunTime:0.003863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3080,200258,984359,725374,792234,447237,860031,874572,589146,273355,541326,941464,92290,927384,612343,92824,1045674,1008160,730334,741853,297401,574873,239185,746416,637666,4302,297477,96248,464163,933432,919577,486427,185241,888986,991030,828032,817905,862512,14428,255035,101729,401548,70700,795317,591704,970592,818615,197516,427052,728496,135066,987602,852439,344619,1025477,129452,156007,656875,288606,662026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]