SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002107s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047663 LIMIT 1 [ RunTime:0.000549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047663 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413204,304083,356958,8304,845597,1008456,490577,798187,290164,1028313,719654,22203,737147,453498,795236,74908,30748,574587,1028732,164033,166119,1010522,651852,281062,476390,900631,135699,606833,471882,814037,563888,570910,843481,644794,534393,816766,967445,835601,905046,969403,1009328,686855,355932,202280,975334,943579,1030340,327672,126605,621381,207467,402877,1021496,435033,1042291,695399,661432,519948,1021397,724709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]