SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201216 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201216 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686272,285396,250204,28832,835405,158736,546457,486061,375877,538772,116705,777088,515032,532962,935990,806928,739669,785331,715202,868842,516216,515265,31739,435645,542357,293572,71284,756178,137678,207253,56833,821683,356076,862890,697164,532187,1014516,456909,28440,512688,459858,706003,103721,395534,862380,378112,538891,47416,294244,674232,716602,62288,80048,1036734,17942,247488,671505,852909,527325,31128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201216 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000679s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201216 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]