SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046513 LIMIT 1 [ RunTime:0.000627s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046513 [ RunTime:0.002919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646049,773066,829399,553861,101783,603856,174093,29,304862,727216,825439,290161,860498,654126,698021,857180,971595,496650,57182,724930,623910,661868,650658,666631,579115,865446,211753,920944,222687,801717,446505,368631,535256,148559,996060,520063,956141,494557,992308,442807,1032519,232809,946336,226307,223470,1001472,850842,188592,86005,834029,562286,863490,138935,969840,587143,162513,311507,614820,962005,510082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]