SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 213111 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 213111 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (184082,412491,366859,705610,539877,450501,99548,439108,263725,1026248,970425,8300,626074,367320,506508,404388,432033,1031221,157032,413713,320986,367146,653910,40275,72748,541744,102530,283357,798024,467770,314710,349341,1000378,1022423,621118,444906,697962,298852,640591,285593,196881,675466,687988,558388,340155,854246,550085,483849,626465,463041,351627,423688,87740,545016,373955,321393,902629,170481,233377,958044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 213111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 213111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000777s ]