SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801182 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801182 [ RunTime:0.001738s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617797,148207,314150,53080,343941,98780,540497,794221,1047492,391526,940483,784463,226095,481085,705059,129561,528234,317216,547787,181845,865106,104577,356679,499494,180104,747371,881017,12296,97654,927490,1037255,90844,181633,299154,415395,1032157,85483,685551,358987,240099,232222,432297,346184,291891,594919,488123,219870,664049,33882,293751,135476,760900,357834,985080,804307,504739,794323,118429,425624,590603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]