SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542251 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542251 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280689,687727,593644,212721,158416,349305,757807,533767,1008428,61991,564070,889892,525117,940186,584584,462669,755769,633869,113209,21252,690625,434153,499580,236586,481293,919859,615983,303737,764320,928676,771025,430273,194846,260056,444265,217921,599344,746569,135490,656134,105456,761768,686836,176885,453417,471205,265400,489474,1026557,609810,534002,546255,1038968,354300,919653,484855,892745,543103,537498,220001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]