SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468506 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468506 [ RunTime:0.004364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018881,394471,628392,294843,207800,846818,961776,137847,697877,882116,416229,866533,973532,424944,84961,36586,804110,94524,795271,210791,1036296,38419,416887,167827,845159,468080,537515,997924,101786,854650,417413,370248,853577,421900,961201,226949,330503,796532,116159,682803,156211,712438,844361,383899,676098,952341,858393,223028,698803,175374,491429,955259,23385,1044124,120936,939393,324006,1019920,843336,207328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000924s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]