SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474281 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474281 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205700,505139,1018804,201107,420818,866165,888137,59078,357633,709318,459519,786456,14470,851579,953977,403006,873297,224037,657363,321579,42948,480536,231702,670917,497932,857636,495385,874274,994770,135123,746522,632689,236179,599893,391565,28069,72128,69503,1038045,709571,213304,718906,335258,991425,357361,934626,234378,745929,507589,212625,778537,252710,460269,912742,958461,426095,651097,207336,1030674,790758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]