SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 430415 LIMIT 1 [ RunTime:0.000755s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 430415 [ RunTime:0.003202s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529072,253662,774740,456670,628575,822221,946968,234714,697206,280454,375287,719020,81574,640901,39344,772686,254635,931486,1021044,1047849,438218,848037,647012,937846,804648,99433,979185,514553,405443,437126,982576,658085,363610,987578,239098,279890,366139,611284,664925,213525,697381,610214,578723,378539,1007506,171966,442419,245139,798128,815398,580176,599288,966636,976886,466773,598007,430470,127313,427347,815212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 430415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 430415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]