SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51103 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51103 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122044,158617,518641,698559,531704,79385,164807,88908,907094,275354,488436,432086,309894,716436,978398,891326,907314,381746,1045093,111512,985884,971899,793483,155275,599873,519584,569038,566944,95219,579840,789538,517931,846267,38935,876569,996493,841883,367406,23931,321373,213595,347668,347370,164406,348476,820146,27779,746164,21908,716300,665263,901086,771769,996720,714633,688670,734506,850151,89701,702446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]