SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 840308 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 840308 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576215,802310,939379,80774,547066,317676,920237,503826,156374,758933,348110,822168,316359,407851,184567,344369,970039,503827,915561,1022283,747614,805279,975723,710804,844891,848191,861734,748168,490492,717790,275088,979799,93438,726717,363630,922324,123036,722548,367807,352686,310036,770991,1016833,867405,910711,733017,79110,891935,257795,1045921,485407,450631,707566,737472,409226,91582,784382,372594,759184,359624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 840308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 840308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]