SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193424 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193424 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (992176,232009,676104,973354,283138,810389,173322,267209,389199,773683,283897,920673,410831,411609,878412,155893,39288,727234,396242,126410,100631,583592,637171,344198,589826,210616,51847,619586,730402,22010,34998,171876,578764,328054,566153,200138,1040064,803087,360181,70979,56459,389653,950775,465936,613428,911065,175341,305821,197469,358501,253944,442754,397227,10046,785488,487146,517546,711839,944341,670318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193424 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193424 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000699s ]