SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644308 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644308 [ RunTime:0.001807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468974,122675,735305,619318,973624,885408,324641,334390,548315,601805,955319,616884,1037460,205685,297525,279854,968515,885965,598737,983432,79683,433549,36733,139265,197389,874007,10815,40545,993917,269004,969073,408021,854850,452341,930401,711181,171600,504152,491778,762706,498807,549365,60121,751184,9871,236431,679016,937126,740474,688890,45758,953643,130857,877010,418276,215335,257685,995978,415889,659958) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]