SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297051 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297051 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431440,28915,365991,164888,162830,80889,783011,626874,105149,997564,959666,751297,805834,326947,93973,427125,534209,462273,590479,733025,847214,869642,869741,24036,235199,564360,40752,69614,635312,542637,546034,332808,631326,526360,1015545,672419,510601,998323,607039,758962,952164,1009958,47007,161582,956111,498735,407914,858736,55287,257193,137388,18919,140678,926518,985321,122991,880129,790883,429507,271928) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001750s ]