SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488971 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488971 [ RunTime:0.005392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180858,367099,613958,396584,546820,226025,759735,882321,676271,638094,1029789,381106,250595,466272,722461,835636,551233,662497,527962,534540,360647,981399,247747,550006,993933,35705,219505,131906,189227,912943,845438,786968,678218,626901,951062,656079,578014,355435,404918,1028477,834498,140853,219228,777897,1034748,892401,492068,412405,748832,886868,682734,601650,141001,253489,343560,468201,886823,10496,461439,511700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003028s ]