SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429125 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429125 [ RunTime:0.003478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023850,949175,114764,914560,314340,937394,611062,366126,979438,440975,759181,926114,422495,628298,670727,67672,813706,627568,1017868,500738,620936,380746,523501,168984,802046,646519,616939,61462,451196,671234,675771,45556,558090,918570,1011908,899155,456219,819537,702158,807944,389036,530237,26929,539151,69116,599495,859848,918353,24226,7255,538165,412239,273166,642792,922055,1034565,66952,182705,905797,656324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429125 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429125 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]