SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013220 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013220 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571255,857413,240361,1045924,752874,1034508,451123,187369,327469,806579,604574,846657,817251,510259,35827,239486,20824,357074,1037234,845123,728949,678590,280250,460764,439262,154720,185541,490652,475373,978621,333205,116684,369322,273013,701292,35771,743402,945598,391946,926909,1036826,71897,106654,254776,896969,182236,336698,187404,413511,459351,329001,742274,730225,835781,27532,137237,446000,979964,11,338085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]