SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 593518 LIMIT 1 [ RunTime:0.000574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593518 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023208,98375,97045,24073,36586,45009,940706,544767,877200,1020173,677794,334054,769991,260937,999988,904107,792468,70347,726332,942405,173435,773037,1047446,688142,28172,134863,854844,584198,58495,1047231,295869,472140,203870,456119,325594,1010425,1024981,651492,64474,468375,495268,177509,829980,167909,780525,919670,647200,497668,325683,200417,580834,742298,102539,537001,110070,364649,800193,924352,727725,435290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]