SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509375 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509375 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71868,501281,686287,256982,276678,115231,990481,796103,700046,362249,308542,787980,514966,332832,475281,947806,450064,515027,475259,508655,412050,374465,296736,505189,766498,274584,341986,103593,83609,428253,643648,84628,427434,75051,896632,651924,714066,162249,352073,199832,399542,650976,34859,1040140,41689,872816,1023245,287597,996469,554906,397846,225175,612350,1022280,691718,796574,782432,653803,447769,971109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509375 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509375 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]