SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020083 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020083 [ RunTime:0.002651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576219,770715,54377,922152,39444,488561,432748,496374,425371,314440,552770,1040672,596430,222078,63461,456677,416767,155580,202142,777144,369551,395396,49813,153315,451534,634122,968815,11734,171804,456471,64353,114632,736041,553792,694242,75025,845824,342968,227204,1015965,997246,285837,1002064,384284,86035,483365,587188,881246,317111,520266,766541,478706,651782,97621,749258,925790,274645,1047479,743803,742551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]