SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035801 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035801 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211963,562267,455119,439508,444157,1003379,457340,626026,381854,489367,728850,705500,513254,213972,324344,48715,545081,280147,31360,690248,475810,15145,78504,498236,272879,258846,729153,112882,606499,976303,940921,580559,648320,585712,571633,156018,5856,248286,951054,178544,56405,278761,600580,220697,635167,124615,243152,35511,269839,751950,658893,552561,427509,483064,83502,918326,494040,58438,585228,902955) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]