SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381016 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381016 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (862594,1047344,288605,441412,536768,870015,798522,729458,456261,273523,908637,962494,1028546,572969,796303,110079,94624,480850,135712,763642,360204,436723,967416,486470,489912,133207,412666,315836,857592,82528,917563,613960,713487,243756,793721,753039,832742,397803,684562,397185,442216,502947,861683,776132,575004,4599,395203,828609,980758,227981,111516,993511,496985,363164,764061,65923,851000,652687,478103,996293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]