SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000291 LIMIT 1 [ RunTime:0.000819s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000291 [ RunTime:0.005618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414833,155678,530439,314934,635049,605352,716414,661268,760137,995114,248000,927010,268600,51120,302397,819565,215098,762511,476236,769125,189606,178389,727666,1037735,962883,941770,696516,567710,9881,883014,348046,70895,976697,7728,76335,290718,433114,856884,935063,282262,276926,778416,878852,451162,329468,559603,1003490,876678,121109,854592,376966,247910,632848,568907,655674,919927,170880,1011876,690550,379996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002655s ]