SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 727881 LIMIT 1 [ RunTime:0.003716s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 727881 [ RunTime:0.002550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (418827,134397,14454,161458,110507,918408,962406,410646,293077,754943,96633,754268,70122,683771,323874,54388,69129,270495,124181,695915,896038,562076,671809,278321,288599,735976,752301,995973,14201,1028945,656102,432957,1006425,118544,439152,946229,799142,310505,917896,179809,515655,224810,598724,204459,236368,506210,434233,910946,152105,852020,713499,1029877,269065,901283,1000889,785538,575182,251011,108121,1021814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 727881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 727881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005465s ]