SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502588 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502588 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219198,705477,826521,814040,341827,590216,932135,573908,208619,800189,776751,386780,338415,1037667,805054,128560,113884,443435,911220,316074,103073,231278,988948,249305,940200,711590,217426,505785,545960,455726,239574,394334,414427,404796,1046697,568888,979685,17192,204524,653214,1006364,859268,401913,139398,123380,953284,820926,578216,30520,463144,581152,924328,161731,673119,685273,190047,479949,691293,955890,235156) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]