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` = 574014 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574014 [ RunTime:0.002045s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297424,199964,271772,373988,75861,598141,415529,698349,64981,103227,40035,407002,277164,246393,788324,446066,460390,423213,51606,694664,135617,586893,291500,788512,8785,1044734,471157,537989,684571,469732,548581,373690,1012535,702261,621260,217626,306455,251630,554859,226976,517018,904391,638166,726219,510551,1023860,309108,469139,964662,104202,140366,270002,914014,112715,22728,985455,96123,412263,92526,971474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574014 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574014 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]