SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283156 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283156 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52485,941353,1035178,1039112,273441,165394,737203,493121,330337,187208,618463,471703,688638,388096,611282,328114,291875,1004740,358987,217620,625905,619827,923782,79019,173259,964354,255327,1039908,748999,691809,330084,367779,130926,883778,555230,374052,959011,393694,899255,1020264,61286,609159,20685,424650,855342,974402,845579,139068,205410,537599,258507,956839,473034,746764,1011278,89880,1047230,568058,203618,1004687) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]