SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501712 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501712 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657527,485200,841269,250581,249516,287302,338529,810492,918804,491032,357626,971642,421929,144046,453628,256988,1009982,733650,98702,885610,700449,911526,413209,83159,679093,355984,718505,476586,160015,805695,145870,993833,287504,322093,208467,919306,307165,709626,401493,70442,221243,395148,375883,80148,670403,415904,568995,166274,389530,673818,158383,985791,700879,18965,695566,145876,226467,184185,837554,685253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002294s ]