SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103844 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103844 [ RunTime:0.003754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17278,449812,895095,228670,764739,365187,652544,673902,856217,804343,874727,705416,579467,104552,1003026,124674,35263,635423,152336,496200,809713,507266,46447,588673,653827,425475,389557,406925,655513,665831,1044121,994610,136029,427097,311168,777060,389486,95347,634912,645748,290884,843151,66121,761654,355324,514755,998396,704714,680210,80765,412745,546744,459559,996807,820774,170662,136942,251970,885301,35585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001723s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]