SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592623 LIMIT 1 [ RunTime:0.000557s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592623 [ RunTime:0.001834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235169,129922,404409,528485,102107,1010040,923158,94451,857597,415703,258440,41996,254940,356257,972180,826156,96802,547141,176147,521990,794030,839891,912361,52704,254749,55,821236,168795,740266,916512,350849,619004,661341,800352,564579,380360,886981,532137,323325,1039201,837239,1023070,920994,758765,76477,813278,407786,446197,185603,725106,84024,483347,416431,70457,573479,251303,449207,355654,866332,439394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]