SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013969 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013969 [ RunTime:0.003258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546161,979224,221940,1020203,546376,912583,445317,369092,51794,420460,324792,615486,206669,429392,104343,314698,263412,26436,317005,565682,877324,684394,234647,158592,814552,905060,228311,598931,898888,931064,721207,999830,269210,434343,599436,120007,99198,960474,445840,239841,414048,878266,915517,81322,47470,234405,325135,497152,16871,655846,98058,657313,587821,195078,824514,240575,300898,771303,957728,49097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013969 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000514s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013969 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001253s ]