SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201607 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201607 [ RunTime:0.002760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741936,914805,112922,9560,757224,183933,240420,873120,839160,282656,973045,428022,932493,247158,937556,198114,582265,276103,63986,581430,414275,435012,297049,226548,770767,13583,752208,689145,341387,841357,562805,485853,300725,714577,850609,786217,252541,1043408,260007,335712,149135,1031132,756046,962453,676445,1019374,843227,240561,501691,1030634,171462,585444,426111,398886,592606,734320,937522,945650,625588,607043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]