SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346010 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346010 [ RunTime:0.001667s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (789030,916731,666214,802653,358574,404043,1032619,939138,947306,539940,162123,770639,594963,528863,812791,671745,767786,534166,471352,1014491,575471,84656,1020523,306322,300102,486121,977820,161820,402818,433573,65175,359845,339696,555887,658822,465213,462906,746005,955291,7310,539389,1008628,284878,47608,484788,133702,90542,523770,282592,425767,709720,1032505,1023898,774627,69424,87120,808596,489105,757656,83917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]