SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399800 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399800 [ RunTime:0.002647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519254,806457,478215,890108,496457,473335,604804,97213,262401,273768,601558,352849,856889,335978,1042552,831335,427506,1018736,536853,240361,477817,645452,553135,244030,299399,1023420,390443,973990,559238,248321,785565,743376,274697,460664,1020730,969487,653530,189075,74761,890679,521687,500478,1022411,973144,408841,293504,856639,337367,597159,368722,538085,770591,832680,567483,747661,601210,160988,515527,459905,350105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]