SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002643s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 956760 LIMIT 1 [ RunTime:0.003761s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 956760 [ RunTime:0.003650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220689,658634,544390,574879,995018,382966,130487,125689,27008,446807,33932,668684,294969,899532,950815,287820,175049,318745,552015,133364,536046,243932,377445,734011,646852,199618,325697,256562,953742,91350,227889,657501,126164,803778,751502,94702,1038126,8095,753058,881543,284330,764189,1005236,212267,597249,789675,560066,233894,449429,964512,842516,396706,473415,143653,1005475,1038039,459848,879010,373802,873037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 956760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 956760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]