SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391781 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391781 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877437,277160,773217,868180,268863,930235,465957,628853,241954,106487,996541,633604,154966,974257,720922,110629,1009683,337744,862372,195014,146374,731585,630266,225111,893764,29493,934355,506344,13514,270249,140391,649205,747476,526102,97971,329507,246914,196561,93974,1019114,481770,173859,356235,60137,895581,430194,746458,1029253,443251,629561,1047190,225688,438427,964253,177507,627603,596958,921227,679454,228517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001354s ]